
CREATE TABLE [dbo].[ForgottenPasswords](
	[IdForgottenPassword] [bigint] IDENTITY(1,1) NOT NULL,
	[IdUser] [bigint] NOT NULL,
	[RequestKey] [uniqueidentifier] NOT NULL,
	[RequestDate] [datetime2](7) NOT NULL,
	[RequestProcessed] [bit] NOT NULL,
	[ProcessDate] [datetime2](7) NULL,
 CONSTRAINT [PK_ForgottenPasswords] PRIMARY KEY CLUSTERED 
(
	[IdForgottenPassword] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


ALTER TABLE [dbo].[ForgottenPasswords] ADD  CONSTRAINT [DF_ForgottenPasswords_RequestDate]  DEFAULT (getdate()) FOR [RequestDate]

ALTER TABLE [dbo].[ForgottenPasswords] ADD  CONSTRAINT [DF_ForgottenPasswords_RequestProcessed]  DEFAULT ((0)) FOR [RequestProcessed]


GO

